From a84462b47c8b2100caa02958623817981179d068 Mon Sep 17 00:00:00 2001 From: Stevan Earl Date: Thu, 23 Jul 2026 16:12:29 -0700 Subject: [PATCH] fix: normalize aggression text for problems #77, #78, and #80 --- conversion/clean.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) diff --git a/conversion/clean.sql b/conversion/clean.sql index c1a2224..28d320b 100644 --- a/conversion/clean.sql +++ b/conversion/clean.sql @@ -677,6 +677,16 @@ SET END ; +-- Problems #77, #78, and #80 +-- The target columns are NOT NULL but allow the empty string. +UPDATE aggression_event + SET ae_recipient_behavior = COALESCE(ae_recipient_behavior, '') + , ae_full_description = COALESCE(ae_full_description, '') + , ae_aggressor_behavior = COALESCE(ae_aggressor_behavior, '') + WHERE ae_recipient_behavior IS NULL + OR ae_full_description IS NULL + OR ae_aggressor_behavior IS NULL; + -- Problem #101 UPDATE aggression_event SET ae_fol_b_focal_id = 'UNK' -- 2.34.1